<?php
// START -- MySQL Settings
include('config.php');
// END -- MySQL Settings

// MySQL Server Connection
mysql_connect($host,$username,$password);
mysql_select_db($database);

// MySQL Server Request: Get Information
$result = mysql_query("SELECT * FROM produkte"); // ausführen des selects und speichern in ein resultset
$i = 1;
while($row = mysql_fetch_array($result)) {
	 echo('<td>');	 	
	 		echo($row['Name'] .': <span id="price'.$i.'">'.$row['Preis_AB'].'</span> &euro; <br>');          
			// echo('<input type="button" style="float:left" value=" + " onclick="add(\''.$row['Kuerzel']. '\');" />');
            echo('<b><font size="3.0em">Bestellung: <input type="text" id="'.$row['Kuerzel']. '" name="drink" style="width:25px; border:none; font-weight: bold;" " value="0" /></b></font>');  //readonly
			//echo('<b>Bestellung: <span id="'.$row['Kuerzel']. '" name="drink" style="width:90px;"/>0</span></b>');   			
			//echo('<input type="button" value=" - " onclick="subt(\''.$row['Kuerzel']. '\');" style="width:20px; height:20px;"/>');			
	 echo('</td>');
	 
	 $i++;
}
?>